package com.rainng.coursesystem.dao.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.rainng.coursesystem.model.bo.RegisterStatusBO;
import com.rainng.coursesystem.model.vo.request.LoginVO;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
public interface RegisterMapper extends BaseMapper<RegisterStatusBO> {
    @Select("select member_id from member where member_number = #{number}")
    String m_selectByNumber(String number);

    @Select("select member_password from member where member_number = #{number}")
    String m_selectPdByNumber(String number);

    @Select("select leader_id from leader where leader_number = #{number}")
    String l_selectByNumber(String number);

    @Select("select member_password from leader where leader_number = #{number}")
    String l_selectPdByNumber(String number);
}
